ReSQLite: Replicating SQLite using Ra
نویسندگان
چکیده
We present a simple implementation of a replicated SQLite database system. While SQLite is not optimized for high-concurrency workloads or large data needs, its simplicity still makes it an aractive choice for simple applications and we envision certain use-cases are out-of-scope for SQLite today given its lack of support for replication out of the box. ReSQLite is a simple implementation of a replicated SQLite system built using the Ra consensus algorithm. It is built using a new Ra implementation built from scratch and existing SQLite3 drivers for Golang. Whilst many features remain to be added to ReSQLite, enabling dynamic cluster size changes for instance, it currently supports leader election and log replication thus making it easy to run a replicated SQLite database across multiple machines, enabling system logs or some cached information to survie machine failures. We also present a simple ReSQLite client to interface with the system and nally discuss the limitations of the system.
منابع مشابه
Pocket Data: The Need for TPC-MOBILE
Embedded database engines such as SQLite provide a convenient data persistence layer and have spread along with the applications using them to many types of systems, including interactive devices such as smartphones. Android, the most widely-distributed smartphone platform, both uses SQLite internally and provides interfaces encouraging apps to use SQLite to store their own private structured d...
متن کاملSQL Statement Logging for Making SQLite Truly Lite
The lightweight codebase of SQLite was helpful in making it become the de-facto standard database in most mobile devices, but, at the same time, forced it to take lesscomplicated transactional schemes, such as physical page logging, journaling, and force commit, which in turn cause excessive write amplification. Thus, the write IO cost in SQLite is not lightweight at all. In this paper, to make...
متن کاملA Reconstructing Android User Behavior Approach based on YAFFS2 and SQLite
Nowadays, a variety of Android user behavior information is automatically stored in SQLite to indicate when and what user behavior took places. In this paper, an approach to reconstruct Android user behavior from YAFFS2 based on SQLite is proposed. Based on the storage mechanism of YAFFS2 file system and the file structures of SQLite, all of the SQLite records can be recovered from the Android ...
متن کاملTransforming SQLITE to Run on a Bare PC
SQLITE is a popular small open-source database management system with many versions that run on popular platforms. However, there is currently no version of the SQLITE application that runs on a bare PC. Since a bare PC does not provide any form of operating system (or kernel) support, bare PC applications need to be completely self-contained with their own interfaces to the hardware. Such appl...
متن کامل